Last Updated: 12/12/2023

Export the BallotTrax Ballot Status File

The BallotTrax Ballot Status file lists the date each ballot was delivered for a selected election as well as the current ballot status, returned processing date and, when applicable, referral reason.

Note: The Master Voter file must first be exported and uploaded in BallotTrax before completing this procedure.

To export the Ballot Status file:

If needed, change the election focus to the applicable Active election.
Go to ELECTIONS > Election Utilities > BallotTrax > Ballot Status File.
Select Ballot Status File and click Export.

Leave the default file location (either C:\Documents or your last selected location) and/or default file name (BTVbmStatusYYYY-MM-DD{time}) or select a different location and/or name, and then save the file in CSV format.

What's in the Ballot Status file?

The export file contains the following column headings with relevant and current data for each, if found:

ElectionNumber	The election in focus.
VoterID	The voter's VUID.
BallotStatus	The current state of the ballot (i.e., Requested, Accepted, Rejected, RejectedCurable, Outbound, Undeliverable). For a description of each status, see What Does Each Status Mean? below.
MailedDate	The date of ballot delivery.
ReturnedDate	The date the returned ballot was processed in Voter Focus.
VbmRequestPrecinct	The voter's normal precinct or, if applicable, the precinct override assignment.
VbmParty	The party, if selected for the ballot.
RejectionReason	The single-digit code assigned to the ballot referral reason.
RejectionDescription	The referral reason description.
IsReinstated	The status of whether the ballot was reinstated (TRUE or FALSE).
IsSignatureRelatedReason	The status of whether the ballot was referred due to a missing or mismatching signature (TRUE or FALSE).

Note: The BallotTrax export creates a row for each eligible voter with the column headings listed above, regardless if there are any ballot results from the export.